clear all
set more off

global rawdata "data directory here" 
global output "output directory here"

clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   9 ///
int ne 360-369 ///
int nem 370-379 ///
int nef 380-389 ///
int nworker 480-489 ///
int nworkerm 490-499 ///
int nworkerf 500-509 ///
int nworker_white 440-449 ///
int nworker_blue 400-409 ///
str ind 926-928 ///
int revenue 898-911 ///
int wagesum 548-561 ///
int wagesum_white 534-547 ///
int wagesum_blue 520-533 ///
str id 929-935 ///
int equity 10-23 ///
int asset 346-359 ///
int cost_material 660-673 ///
int asset_land 290-303 ///
int asset_factory 304-317 ///
int asset_machine 318-331 /// 
using ms1982.txt, clear

keep year state city eyear org ne* nworker* ind revenue id wagesum* equity asset* cost*
cd $output
save 1982simple.dta,replace

 
*===============================
*1983
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   9 ///
int ne 24-31 ///
int nem 32-39 ///
int nef 40-47 ///
int nworker 96-103 ///
int nworkerm 104-111 ///
int nworkerf 112-119 ///
str ind 1096-1098 ///
int revenue 1068-1081 ///
int wagesum 136-143 ///
int wagesum_white 128-135 ///
int wagesum_blue 120-127 ///
str id 1099-1105 ///
int equity 10-23 ///
int asset 914-927 ///
int cost_material 144-157 /// 
int nworker_white 72-79 ///
int nworker_blue 48-55 ///
int asset_land 830-843 ///
int asset_factory1 844-857 ///
int asset_factory2 858-871 ///
int asset_machine1 872-885 /// 
int asset_machine2 886-899 /// 
using ms1983.txt, clear

gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2

gen asset_machine = asset_machine1 + asset_machine2
drop asset_machine1 asset_machine2

keep year state city eyear org ne* nworker* ind revenue id wagesum* equity asset* cost*  
cd $output
save 1983simple.dta,replace

 
 

*===============================
*1984
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   9 ///
int ne 24-31 ///
int nem 32-39 ///
int nef 40-47 ///
int nworker 120-127 ///
int nworkerm 128-135 ///
int nworkerf 136-144 ///
str ind 922-924 ///
int revenue 894-907 ///
int wagesum 180-193 ///
int wagesum_white 166-179 ///
int wagesum_blue 152-165 ///
str id 925-931 ///
int equity 10-23 ///
int asset 880-893 ///
int cost_material 194-207 ///
int nworker_white 88-95 ///
int nworker_blue 56-63 ///
int asset_land 824-837 ///
int asset_factory 838-851 /// 
int asset_machine 852-865 /// 
using ms1984.txt, clear

keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost*  
cd $output
save 1984simple.dta,replace

 
*===============================
*1985
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   9 ///
int ne 24-31 ///
int nem 32-39 ///
int nef 40-47 ///
int nworker 120-127 ///
int nworkerm 128-135 ///
int nworkerf 136-144 ///
int nworker_blue 56-63 ///
int nworker_white 88-95 ///
str ind 1090-1092 ///
int revenue 1062-1075 ///
int wagesum 180-193 ///
int wagesum_white 166-179 ///
int wagesum_blue 152-165 ///
str id 1093-1099 ///
int equity 10-23 ///
int asset 1048-1061 /// 
int cost_material 264-277 ///
int asset_land 992-1005 ///
int asset_factory 1006-1019 /// 
int asset_machine 1020-1033 /// 
using ms1985.txt, clear

keep year state city eyear org ne* nworker* ind revenue id wagesum* equity asset* cost*  
cd $output
save 1985simple.dta,replace
  
  
*===============================
*1986
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   9 ///
int ne 24-31 ///
int nem 32-39 ///
int nef 40-47 ///
int nworker 120-127 ///
int nworkerm 128-135 ///
int nworkerf 136-144 ///
str ind 922-924 ///
int revenue 894-907 ///
int wagesum 180-193 ///
int wagesum_white 166-179 ///
int wagesum_blue 152-165 ///
str id 925-931 ///
int equity 10-23 ///
int asset 880-893 /// 
int cost_material 264-277 ///
int nworker_white 88-95 ///
int nworker_blue 56-63 ///
int asset_land 824-837 ///
int asset_factory 838-851 /// 
int asset_machine 852-865 /// 
using ms1986.txt, clear

keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1986simple.dta,replace
 

*===============================
*1987
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   9 ///
int ne 24-31 ///
int nem 32-39 ///
int nef 40-47 ///
int nworker 120-127 ///
int nworkerm 128-135 ///
int nworkerf 136-144 ///
str ind 922-924 ///
int revenue 894-907 ///
int wagesum 180-193 ///
int wagesum_white 166-179 ///
int wagesum_blue 152-165 ///
str id 925-931 ///
int equity 10-23 ///
int asset 880-893 ///
int cost_material 264-277 ///
int nworker_white 88-95 ///
int nworker_blue 56-63 ///
int asset_land 824-837 ///
int asset_factory 838-851 /// 
int asset_machine 852-865 ///
using ms1987.txt, clear
 
keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost*  
cd $output
save 1987simple.dta,replace

 
*===============================
*1988
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 22-25 ///
str org   7 ///
int ne 28-35 ///
int nem 36-43 ///
int nef 44-51 ///
int nworker 124-131 ///
int nworkerm 132-139 ///
int nworkerf 140-148 ///
str ind 1444-1446 ///
int revenue 1416-1429 ///
int wagesum 184-197 ///
int wagesum_white 170-183 ///
int wagesum_blue 156-169 ///
str id 1447-1453 ///
int equity 8-21 ///
int asset 1402-1415 ///
int cost_material 408-421 ///
int nworker_white 92-99 ///
int nworker_blue 60-67 ///
int asset_land 1318-1331 ///
int asset_factory1 1332-1345 /// 
int asset_factory2 1346-1359 /// 
int asset_machine1 1360-1373 /// 
int asset_machine2 1374-1387 ///
using ms1988.txt, clear

gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1  asset_factory2

gen asset_machine = asset_machine1 + asset_machine2
drop asset_machine1  asset_machine2
 
keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost*  
cd $output
save 1988simple.dta,replace

 

*===============================
*1989
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-10 ///
str org   13 ///
int ne 28-37 ///
int nem 38-47 ///
int nef 48-57 ///
int nworker 188-197 ///
int nworkerm 198-207 ///
int nworkerf 208-217 ///
str ind 998-1000 ///
int revenue 970-983 ///
int wagesum 256-269 ///
int wagesum_white 242-255 ///
int wagesum_blue 228-241 ///
str id 1001-1007 ///
int equity 14-27 ///
int asset 956-969 ///
int cost_material 340-353 ///
int nworker_white 148-157 ///
int nworker_blue 108-117 ///
int asset_land 900-913 ///
int asset_factory 914-927 /// 
int asset_machine 928-941 /// 
using ms1989.txt, clear
 
keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost*  
cd $output
save 1989simple.dta,replace

 

*===============================
*1990
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   11 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-236 ///
str ind 1282-1284 ///
int revenue 1252-1266 ///
int wagesum 277-291 ///
int wagesum_white 262-276 ///
int wagesum_blue 247-261 ///
str id 1285-1291 ///
int equity 12-26 /// 
int a1 1162-1176 ///
int a2 1177-1191 ///
int a3 1192-1206 ///
int a4 1207-1221 ///
int a5 1222-1236 ///
int a6 1237-1251 ///
int cost_material 367-381 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 1162-1176 ///
int asset_factory 1177-1191 /// 
int asset_machine 1192-1206 /// 
using ms1990.txt, clear

gen asset = a1+a2+a3+a4+a5+a6  
 
keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1990simple.dta,replace

 

*===============================
*1991
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str state 3-4 ///
str city 5-6 ///
str eyear 7-8 ///
str org   11 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-236 ///
str ind 1297-1299 ///
int revenue 1267-1281 ///
int wagesum 277-291 ///
int wagesum_white 262-276 ///
int wagesum_blue 247-261 ///
str id 1300-1306 ///
int equity 12-26 ///
int asset 1252-1266 ///
int cost_material 367-381 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 1162-1176 ///
int asset_factory 1177-1191 /// 
int asset_machine 1192-1206 /// 
using ms1991.txt, clear
 
 
keep year state city eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1991simple.dta,replace
 
 
*===============================
*1992
*===============================

clear
cd $rawdata

infix str year 1-2 ///
str location 3-7 ///
str eyear 8-9 ///
str org   12 ///
int ne 28-38 ///
int nem 39-49 ///
int nef 50-60 ///
int nworker 204-214 ///
int nworkerm 215-225 ///
int nworkerf 226-237 ///
str ind 1313-1315 ///
int revenue 1268-1282 ///
int wagesum 278-292 ///
int wagesum_white 263-277 ///
int wagesum_blue 248-262 ///
str id 1316-1322 ///
int equity 13-27 ///
int asset 1253-1267 ///
int cost_material 368-382 ///
int nworker_white 160-170 ///
int nworker_blue 116-126 ///
int asset_land 1163-1177 ///
int asset_factory 1178-1192 /// 
int asset_machine 1193-1207 ///
using ms1992.txt, clear
 
keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1992simple.dta,replace

 
*===============================
*1993
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str location 3-7 ///
str eyear 8-9 ///
str org   12 ///
int ne 28-38 ///
int nem 39-49 ///
int nef 50-60 ///
int nworker 204-214 ///
int nworkerm 215-225 ///
int nworkerf 226-237 ///
str ind 1298-1300 ///
int revenue 1268-1282 /// 
int wagesum 278-292 ///
int wagesum_white 263-277 ///
int wagesum_blue 248-262 ///
str id 1301-1307 ///
int equity 13-27 ///
int asset 1253-1267 ///
int cost_material 368-382 ///
int nworker_white 160-170 ///
int nworker_blue 116-126 ///
int asset_land 1163-1177 ///
int asset_factory 1178-1192 /// 
int asset_machine 1193-1207 /// 
using ms1993.txt, clear
 
keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1993simple.dta,replace

 
*===============================
*1994
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str location 3-7 ///
str eyear 8-9 ///
str org   12 ///
int ne 28-38 ///
int nem 39-49 ///
int nef 50-60 ///
int nworker 204-214 ///
int nworkerm 215-225 ///
int nworkerf 226-237 ///
str ind 1313-1315 ///
int revenue 1268-1282 /// 
int wagesum 278-292 ///
int wagesum_white 263-277 ///
int wagesum_blue 248-262 ///
str id 1316-1322 ///
int equity 13-27 ///
int asset 1253-1267 ///
int cost_material 368-382 ///
int nworker_white 160-170 ///
int nworker_blue 116-126 ///
int asset_land 1163-1177 ///
int asset_factory 1178-1192 /// 
int asset_machine 1193-1207 /// 
using ms1994.txt, clear
 
keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1994simple.dta,replace
 

*===============================
*1995
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str location 3-7 ///
str eyear 8-9 ///
str org   12 ///
int ne 28-38 ///
int nem 39-49 ///
int nef 50-60 ///
int nworker 204-214 ///
int nworkerm 215-225 ///
int nworkerf 226-237 ///
int nworker_blue 116-126 ///
int nworker_white 160-170 ///
str ind 1313-1315 ///
int revenue 1268-1282 /// 
int wagesum 278-292 ///
int wagesum_white 263-277 ///
int wagesum_blue 248-262 ///
str id 1316-1322 ///
int equity 13-27 ///
int asset 1253-1267 ///
int cost_material 368-382 ///
int asset_land 1163-1177 ///
int asset_factory 1178-1192 /// 
int asset_machine 1193-1207 /// 
using ms1995.txt, clear

keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost*  
cd $output
save 1995simple.dta,replace
  


*===============================
*1996
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str location 3-7 /// 
str eyear 8-9 ///
str org   12 ///
int ne 28-38 ///
int nem 39-49 ///
int nef 50-60 ///
int nworker 204-214 ///
int nworkerm 215-225 ///
int nworkerf 226-237 ///
str ind 1298-1300 ///
int revenue 1268-1282 /// 
int wagesum 278-292 ///
int wagesum_white 263-277 ///
int wagesum_blue 248-262 ///
str id 1301-1307 ///
int equity 13-27 ///
int asset 1253-1267 ///
int cost_material 368-382 ///
int nworker_white 160-170 ///
int nworker_blue 116-126 ///
int asset_land 1163-1177 ///
int asset_factory 1178-1192 /// 
int asset_machine 1193-1207 /// 
using ms1996.txt, clear
 
keep year location eyear org ne* nworker* ind revenue id wagesum* equity asset* cost*  
cd $output
save 1996simple.dta,replace

 

*===============================
*1997
*===============================
clear
cd $rawdata

infix str year 1-2 ///
str location 3-7 ///
str eyear 8-9 ///
str org   12 ///
int ne 28-38 ///
int nem 39-49 ///
int nef 50-60 ///
int nworker 204-214 ///
int nworkerm 215-225 ///
int nworkerf 226-237 ///
str ind 1298-1300 ///
int revenue 1268-1282 /// 
int wagesum 278-292 ///
int wagesum_white 263-277 ///
int wagesum_blue 248-262 ///
str id 1301-1307 ///
int equity 13-27 ///
int asset 1253-1267 ///
int cost_material 368-382 ///
int nworker_white 160-170 ///
int nworker_blue 116-126 ///
int asset_land 1163-1177 ///
int asset_factory 1178-1192 /// 
int asset_machine 1193-1207 /// 
using ms1997.txt, clear

keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 1997simple.dta,replace
 
 
*===============================
*1998
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-12 ///
str org   15 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-235 ///
str ind 1017-1019 ///
int revenue 995-1005 /// 
int wagesum 269-279 ///
int wagesum_white 258-268 ///
int wagesum_blue 247-257 ///
str id 1020-1026 ///
int equity 16-26 ///
int asset 984-994 ///
int cost_material 335-345 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 918-928 ///
int asset_factory 929-939 /// 
int asset_machine 940-950 /// 
using ms1998.txt, clear
 
keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost*  
cd $output 
save 1998simple.dta,replace
 
*===============================
*1999
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-14 ///
str org   15 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-235 ///
str ind 1083-1085 ///
int revenue 1061-1071 /// 
int wagesum 269-279 ///
int wagesum_white 258-268 ///
int wagesum_blue 247-257 ///
str id 1097-1103 ///
int equity 16-26 ///
int asset 1050-1060 ///
int cost_material 335-345 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 973-983 ///
int asset_factory1 984-994 /// 
int asset_factory2 995-1005 /// 
int asset_machine 1006-1016 /// 
using ms1999.txt, clear

gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2

keep year location eyear org ne* nworker* ind revenue id wagesum* equity asset* cost* 
cd $output
save 1999simple.dta,replace
 
 
*===============================
*2000
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-14 ///
str org   15 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-235 ///
str ind 1083-1085 ///
int revenue 1061-1071 /// 
int wagesum 269-279 ///
int wagesum_white 258-268 ///
int wagesum_blue 247-257 ///
str id  1086-1092 ///
int equity 16-26 ///
int asset 1050-1060 ///
int cost_material 335-345 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 973-983 ///
int asset_factory1 984-994 /// 
int asset_factory2 995-1005 /// 
int asset_machine 1006-1016 ///
using ms2000.txt, clear
  
gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2

keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 2000simple.dta,replace




*===============================
*2001
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-14 ///
str org   15 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-235 ///
str ind 1083-1085 ///
int revenue 1061-1071 /// 
int wagesum 269-279 ///
int wagesum_white 258-268 ///
int wagesum_blue 247-257 ///
str id  1086-1092 ///
int equity 16-26 ///
int asset 1050-1060 ///
int cost_material 335-345 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 973-983 ///
int asset_factory1 984-994 /// 
int asset_factory2 995-1005 /// 
int asset_machine 1006-1016 /// 
using ms2001.txt, clear
 
gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2
  
keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 2001simple.dta,replace



*===============================
*2002
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 10-13 ///
str org   15 ///
int ne 27-37 ///
int nem 38-48 ///
int nef 49-59 ///
int nworker 203-213 ///
int nworkerm 214-224 ///
int nworkerf 225-235 ///
str ind 1138-1140 ///
int revenue 1116-1126 /// 
int wagesum 313-323 ///
int wagesum_white 302-312 ///
int wagesum_blue 291-301 ///
str id  1141-1147 ///
int equity 16-26 ///
int asset 1105-1115 ///
int cost_material 390-400 ///
int nworker_white 159-169 ///
int nworker_blue 115-125 ///
int asset_land 1028-1038 ///
int asset_factory1 1039-1049 /// 
int asset_factory2 1050-1060 /// 
int asset_machine 1061-1071 /// 
using ms2002.txt, clear
 
gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2 

keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 2002simple.dta,replace



*===============================
*2003
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-14 ///
str org   17 ///
int ne 29-39 ///
int nem 40-50 ///
int nef 51-61 ///
int nworker 205-215 ///
int nworkerm 216-226 ///
int nworkerf 227-237 ///
str ind 1140-1142 ///
int revenue 1118-1128 /// 
int wagesum 315-325 ///
int wagesum_white 304-314 ///
int wagesum_blue 293-303 ///
str id  1143-1149 ///
int equity 18-28 ///
int asset 1107-1117 ///
int cost_material 392-402 ///
int nworker_white 161-171 ///
int nworker_blue 117-127 ///
int asset_land 1030-1040 ///
int asset_factory1 1041-1051 /// 
int asset_factory2 1052-1062 /// 
int asset_machine 1063-1073 /// 
using ms2003.txt, clear
 
gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2 
 
keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 2003simple.dta,replace


*===============================
*2004
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-14 ///
str org   17 ///
int ne 29-39 ///
int nem 40-50 ///
int nef 51-61 ///
int nworker 205-215 ///
int nworkerm 216-226 ///
int nworkerf 227-237 ///
str ind 1140-1142 ///
int revenue 1118-1128 /// 
int wagesum 315-325 ///
int wagesum_white 304-314 ///
int wagesum_blue 293-303 ///
str id  1143-1149 ///
int equity 18-28 ///
int asset 997-1007 ///
int cost_material 392-402 ///
int nworker_white 161-171 ///
int nworker_blue 117-127 ///
int asset_land 920-930 ///
int asset_factory1 931-941 /// 
int asset_factory2 942-952 /// 
int asset_machine 953-963 /// 
using ms2004.txt, clear
 
gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2 

keep year location eyear org ne* nworker* ind revenue wagesum* id equity asset* cost* 
cd $output
save 2004simple.dta,replace



*===============================
*2005
*===============================
clear
cd $rawdata

infix str year 1-4 ///
str location 5-9 ///
str eyear 11-14 ///
str org   17 ///
int ne 54-65 ///
int nem 66-77 ///
int nef 78-89 ///
int nworker 246-257 ///
int nworkerm 258-269 ///
int nworkerf 270-281 ///
int nworker_blue 150-161 ///
int nworker_white 198-209 ///
str ind 1266-1268 ///
int revenue 1242-1253 /// 
int wagesum 366-377 ///
int wagesum_white 354-365 ///
int wagesum_blue 342-353 ///
str id 1269-1275 ///
int equity 30-41 ///
int asset 1110-1121 ///
int cost_material 450-461 ///
int asset_land 1026-1037 ///
int asset_factory1 1038-1049 /// 
int asset_factory2 1050-1061 /// 
int asset_machine 1062-1073 /// 
using ms2005.txt, clear


gen asset_factory = asset_factory1 + asset_factory2
drop asset_factory1 asset_factory2 

keep year location eyear org ne* nworker* ind revenue id wagesum* equity asset* cost* 
cd $output
save 2005simple.dta,replace


